OpenEdge Data Management:<br />Database Administration PROMON Activity option

Displays an overview of your system activity. Figure 19–6 shows an example of this option’s output.

Activity - Sampled at 04/29/04 15:09 for 0:03:39. Event Total Per Sec Event Total Per Sec Commits 50 0.2 Undos 0 0.0 Record Updates 0 0.0 Record Reads 3709 16.9 Record Creates 0 0.0 Record Deletes 0 0.0 DB Writes 3 0.0 DB Read 473 2.2 BI Writes 2 0.0 BI Reads 198 0.9 AI Writes 0 0.0 Record Locks 210 1.0 Record Waits 0 0.0 Checkpoints 0 0.0 Buffs Flushed 0 0.0 Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 % Writes by APW 0 % Writes by BIW 0 % Writes by AIW 0 % Buffer Hits 97 % DB Size 1151 K BI Size 2168 K AI Size 0 K FR chain 12 blocks RM chain 439 blocks Shared Memory 966656 Segments 1 0 Servers, 10 Users (10 Local, 0 Remote, 10 Batch),0 Apws RETURN - repeat, U - continue uninterrupted, Q - quit:

Activity  - Sampled at 04/29/04 15:09 for 0:03:39. 
Event                 Total   Per Sec   Event              Total     Per Sec 
       Commits           50       0.2              Undos       0         0.0 
Record Updates            0       0.0       Record Reads    3709        16.9    
Record Creates            0       0.0     Record Deletes       0         0.0    
     DB Writes            3       0.0           DB Read      473         2.2 
     BI Writes            2       0.0           BI Reads     198         0.9    
     AI Writes            0       0.0        
  Record Locks          210       1.0       Record Waits       0         0.0    
   Checkpoints            0       0.0      Buffs Flushed       0         0.0 
Rec Lock Waits    0 %    BI Buf Waits        0 %    AI Buf Waits    0 % 
Writes by APW     0 %    Writes by BIW       0 %    Writes by AIW   0 % 
Buffer Hits      97 % 
DB Size        1151 K        BI Size    2168 K        AI Size       0 K 
FR chain         12 blocks   RM chain    439 blocks 
Shared Memory 966656         Segments      1 
0 Servers, 10 Users (10 Local, 0 Remote, 10 Batch),0 Apws 
RETURN - repeat, U - continue uninterrupted, Q - quit:

The events that have occurred on the system and the cumulative total number of events and the number of events per second. Table 19–5 defines the event types listed in the Event field. For each event type, PROMON lists the cumulative total number of events and the number of events per second.

Table 19–5: Event types
Event type	Description
Commits	Number of transactions committed.
Undos	Number of transactions rolled back.
Record Updates	Number of records updated.
Record Reads	Number of records read.
Record Creates	Number of records created.
Record Deletes	Number of records deleted.
DB Writes	Number of database blocks written to disk.
DB Reads	Number of database blocks read from disk.
BI Writes	Number of BI blocks written to disk.
BI Reads	Number of BI blocks read.
AI Writes	Number of AI blocks written to disk.
Record Locks	Number of record locks used.
Record Waits	Number of times the database engine waited to access a locked record.
Checkpoints	Number of checkpoints performed.
Buffers Flushed	Number of database buffers flushed during checkpoints.

Percentage of record accesses that result in record lock waits. A record lock wait occurs when the database engine must wait to access a locked record.

Percentage of before-image (BI) buffer waits. A BI buffer wait occurs when the database engine must wait to access a BI buffer.

Percentage of after-image (AI) buffer waits. An AI buffer wait occurs when the database engine must wait to access an AI buffer.

Percentage of database blocks written to disk by the APW; this is a percentage of the total number of database blocks written by the database engine.

Percentage of BI blocks written to disk by the BIW; this is a percentage of the total number of BI blocks written to disk by the database engine.

Percentage of AI blocks written to disk by the AIW; this is a percentage of the total number of AI blocks written.

Percentage of buffer hits. A buffer hit occurs when the database engine locates a record in the buffer pool and does not have to read the record from disk.

Number of blocks on your database’s free chain. The free chain is a chain of empty database blocks.

Number of blocks on your database’s record-management chain. The record-management chain is a chain of partially filled database blocks.

Number of shared-memory segments allocated by the database engine. The size of a shared-memory segment is determined by your kernel configuration.

The last line of the PROMON Activity output summarizes the current number of each type of process running against the database at the time you ran the Activity option, not a cumulative total. Table 19–6 defines the process types.

Table 19–6: Process types
Field	Description
Servers	Number of servers running against your database. This is the current value at the time you ran the Activity option, not a cumulative total.
Users	Number of users running an OpenEdge process. This field is further divided into the type of user: Local, Remote, or Batch. This is the current value at the time you ran the Activity option, not a cumulative total.
Apws	Number of APWs running against your database. This is the current value at the time you ran the Activity option, not a cumulative total.